<test>
  <sql>SELECT	*
FROM	(
			SELECT	*
			FROM	Employees 
			ORDER	BY BirthDate DESC
		) AS D</sql>
  <expectedErrors>
    <expectedError id="OrderByInvalidInSubqueryUnlessTopIsAlsoSpecified" text="The ORDER BY clause is invalid in derived tables, subqueries, and common table expressions, unless TOP is also specified." />
  </expectedErrors>
</test>